CREATE TABLE [dbo].[UserDefinedFieldRef]
(
[UserDefinedFieldKey] [uniqueidentifier] NOT NULL,
[UserDefinedFieldName] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SystemEntityKey] [uniqueidentifier] NOT NULL,
[PropertyDefinitionKey] [uniqueidentifier] NOT NULL,
[UseInSearchFlag] [bit] NOT NULL,
[SortOrder] [int] NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[UserDefinedFieldRef] ADD CONSTRAINT [PK_UserDefinedFieldRef] PRIMARY KEY CLUSTERED ([UserDefinedFieldKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_UserDefinedFieldRef_PropertyDefinitionKey] ON [dbo].[UserDefinedFieldRef] ([PropertyDefinitionKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_UserDefinedFieldRef_SystemEntityKey] ON [dbo].[UserDefinedFieldRef] ([SystemEntityKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[UserDefinedFieldRef] ADD CONSTRAINT [FK_UserDefinedField_Ref_SystemEntity] FOREIGN KEY ([SystemEntityKey]) REFERENCES [dbo].[SystemEntity] ([SystemEntityKey])
GO
ALTER TABLE [dbo].[UserDefinedFieldRef] ADD CONSTRAINT [FK_UserDefinedFieldRef_PropertyDefinition] FOREIGN KEY ([PropertyDefinitionKey]) REFERENCES [dbo].[PropertyDefinition] ([PropertyDefinitionKey])
GO